SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[_DrugDiscount_GetPercent]
    @MemberType NVARCHAR(20) ,
    @DrugId NVARCHAR(5)
AS 
    SELECT  ISNULL(DiscountPercent, 0) AS DiscountPercent
    FROM    dbo.DrugDiscount
    WHERE   MemberType = @MemberType
            AND DrugId = @DrugId

            

GO
